home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
CD ROM Paradise Collection 4
/
CD ROM Paradise Collection 4 1995 Nov.iso
/
database
/
scscrpt1.zip
/
SCSCRIPT.TXT
< prev
next >
Wrap
Text File
|
1994-08-27
|
8KB
|
267 lines
SC-Scripter 1.0 Copyright (C) 1994 SplitCycle Computing - All Rights Reserved
This file contains the following sections:
* Overview
* System requirements
* Installation
* Command line parameters
* Command summary
* Support and questions
======== O V E R V I E W =================================================
SC-Scripter is a fast and easy SQL Server management assistant that
can increase developer and database administrator productivity. It
will generate Transact-SQL scripts for entire databases or individual
objects. It's command line interface allows database definitions to
be generated as part of your complete backup procedures. This program
can be a valuable tool in moving, restoring and examining databases.
SC-Scripter is distributed as Shareware. This means that users are
encouraged, subject to restrictions described in the License Agreement,
to share copies of this program with friends, associates and bulletin
boards. Please remember that if you use this software you are required
to pay the registration fee of $39 as described in files LICENSE.TXT
and ORDER.TXT.
This program is produced by a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware
principle works for you. If you are unable to resolve a
shareware-related problem with an ASP member by contacting the member
directly, ASP may be able to help. The ASP Ombudsman can help you
resolve a dispute or problem with an ASP member, but does not provide
technical support for members' products. Please write to the ASP
Ombudsman at 545 Grover Road, Muskegon, MI 49442 or send a CompuServe
message via easyplex to ASP Ombudsman 70007,3536.
_______
____|__ | (R)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
======== S Y S T E M R E Q U I R E M E N T S ===========================
- Operating system should be one of the following
* DOS 4.0 or above
* Microsoft Windows NT 3.1 or above
* IBM OS/2 2.1 or above
- Network or local access to a Microsoft/Sybase SQL Server version
4.2 or above
- Netlib from Microsoft or Sybase for DOS version 4.21 or above
- SC-Scripter should work if ISQL (MS/Sybase utility) works.
======== I N S T A L L A T I O N =========================================
1) If you already have installed a previous version of SC-Scripter, backup
and delete all files in your SCSCRIPT directory. Otherwise create a
directory to hold the SC-Scripter related files.
Example:
C:\SCSCRIPT
2) Copy all SC-Scripter related files to this directory. At a minimum
you need SCSCRIPT.EXE
3) Add "C:\SCSCRIPT" to your PATH in your AUTOEXEC.BAT file, if you
plan on using SC-Scripter frequently.
4) Run SCSCRIPT.EXE (passing any necessary command line parameters).
Example:
SCSCRIPT -Usa -P <--- assuming C:\SCSCRIPT is in
your PATH or that you are
currently in its directory.
======== C O M M A N D L I N E P A R A M E T E R S ===================
Syntax:
SCScript [-U login id]
[-P password]
[-S server]
[-D database]
[-Q "command line query"]
[-I inputfile]
[-O outputfile]
[-? show syntax summary]
Where
-U login id
is the user login ID (case sensitive)
-P password
is the user login's password (case sensitive). SC-Scripter will
prompt for a password if -P is not passed (password not echoed).
-S server
specifies the SQL Server that you wish to connect to (case sensitive)
-D database
name of database that the connection should initially be made to
-Q "command line query"
executes the specified command and then exist SC-Scripter
-I inputfile
name of file containing a batch of SC-Scripter commands
-O outputfile
name of file to be default destination for any created scripts
-? show syntax summary
lists the available command line parameters
======== C O M M A N D S U M M A R Y ===================================
The following commands are available:
CREATE
DEPENDS
EXIT
HELP
LIST
QUIT
USE
"CREATE"
Generate a database object definition script file.
syntax:
CREATE objectname outputfile
objectname - Name of object for which a script is to be
generated or keyword "ALL". Wild character "%"
is allowed.
outputfile - Any valid filename to be used for script output.
examples (assuming your in the pubs database):
CREATE titles creates a script file for
object "titles". The script
is written to the outputfile
specified on the command line
or to "titles.sql" as a
default.
CREATE rep% miscrep.sql creates a script file for
objects with names starting
with "rep". All output is
written to file "miscrep.sql".
CREATE ALL creates a script file for
all objects in the current
database. The script is
written to the outputfile
specified on the command line
or to "pubs.sql".
"DEPENDS"
Generate database object definitions for all objects that
are dependent on a specified table.
syntax:
DEPENDS tablename outputfile
tablename - Name of user table in current database.
outputfile - Any valid filename to be used for script output.
example:
DEPENDS titles titles.dep creates a script file for
all dependencies of table
"titles", output is written
to "titles.dep".
"EXIT"
Exits the program.
syntax:
EXIT
"HELP"
Displays list of available commands and short description.
syntax:
HELP
"LIST"
List object names that match a specified search criteria.
syntax:
LIST objectname
objectname - Character string used in matching object names
in the current database. Wild character "%" is allowed.
example:
LIST rep% list objects with names starting
with "rep".
"QUIT"
Exits the program.
syntax: QUIT
"USE"
Switches the database context to a specified database.
syntax:
USE database_name
database_name - valid database name in the current server.
example:
USE pubs swith database context to "pubs".
======== S U P P O R T A N D Q U E S T I O N S =======================
Technical support is available at no charge by sending electronic mail
to 73501,1261 on CompuServe, or by sending US Mail to SplitCycle Computing,
13102 Rivergate Lane, Jacksonville, FL 32223. Registered users have
priority but I will try to answer all questions.
When reporting problems with SC-Scripter, please include the following
information:
1) Can the problem be recreated? If so, how?
2) What operating environment did this occur in? Please specify version
of DOS, NT or OS/2.
3) If an error message was displayed, please include the text of the message.
Suggestions for enhancements are welcome from all users. A Windows
version is being worked on and features specific to System 10 will be
added shortly.
======== E N D O F D O C U M E N T ===================================